Automatic Generation of Scripts for Database Creation from Scenario Descriptions

Aims: Database creation is the most critical component of design and implementation any software application. Generally, process creating database from requirement specification a application believed to be extremely hard. This study presents method automatically generate scripts given scenario description specification.
 Study Design: The developed based on set natural language processing (NLP) techniques few algorithms. Standard descriptions presented in popular textbooks Design are used for validation method.
 Place Duration Study: Department Statistics Computer Science, Faculty University Peradeniya, Sri Lanka, Between December 2019 2020.
 Methodology: problem processed using NLP operations such as tokenization, complex word handling, basic group phrase structure merging, template construction extract necessary information required entity relational model. New algorithms proposed convert model logical schema finally script. system can databases (RDB), object (ORDB) Not Only SQL (NoSQL) databases. integrated into web where users type or free text. user select (i.e., one RDB, ORDB, NoSQL) considered their accordingly generates scripts.
 Results: was evaluated 10 connected different domains company, university, airport, etc. all three types performed with impressive accuracies 82.5%, 84.0% 83.5% ORDB NoSQL scripts, respectively.
 Conclusion: mainly focused automatic generation system. Overall, helps speed up development process. Further, provides learning environment people who novices technology.